<?php

class UsersCFSC extends Users
{
	protected $sql = "SELECT m.SnapUserID, m.SnapUserGroupID, u.SnapUserID, u.LongName, u.ShortName, u.Password, u.email, g.GroupName, su.SnapUserID
						FROM (SnapUserGroupMembers AS m
						INNER JOIN SnapUsers AS u ON m.SnapUserID = u.SnapUserID)
						INNER JOIN SnapUserGroups as g ON g.SnapUserGroupID = m.SnapUserGroupID  
						RIGHT JOIN SnapUsersCFSC AS su ON m.SnapUserID = su.SnapUserID";
		
	
}
